SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetLinkByNo] ( @JOL_Link_No INT )
AS 
    SELECT  JOL_Link_No,
            JOL_Link_Title,
            JOL_Link_Type,
            JOL_Link_Website,
            JOL_Link_Remark,
            JOL_Link_AddTime,
            JOL_Link_AddUser,
            JOL_Link_UpdateTime,
            JOL_Link_UpdateUser,
            JOL_Link_ImageUrl
    FROM    dbo.JOL_Link
    WHERE   JOL_Link_No = @JOL_Link_No
GO
